﻿<!DOCTYPE html>
<html>
	<head>
		<title>Add cell background and borders</title>
		<meta charset="utf-8" />
		<meta name="description" content="Adjust the cell style by adding the cell background and borders" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Add cell background and borders</h1>            
            <h3>Add cell background</h3>
            <p>To apply and format cell background,</p>
            <ol>
                <li>
                    select a cell, a range of cells with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination,
                    <p class="note"><b>Note</b>: you can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
                </li>
                <li>to apply a <em>solid color</em> fill to the cell background, click the <b>Background color</b> <div class = "icon icon-backgroundcolor"></div> icon situated at the <b>Home</b> tab of the top toolbar and choose the necessary color. 
                </li>
                <li>to use other fill types, such as a <em>gradient</em> fill or <em>pattern</em>, click the <b>Cell settings</b> <div class = "icon icon-cellsettings_rightpanel"></div> icon at the right sidebar and use the <b>Fill</b> section:
                    <ul>
                        <li>
                            <b>Color Fill</b> - select this option to specify the solid color you want to fill the selected cells with.
                            <p><img alt="Color Fill" src="../images/cell_fill_color.png" /></p>
                            <p id="color">Click the colored box below and select one of the <em>theme colors</em>, or <em>standard colors</em> on the palette, or specify a <em>custom</em> color.</p>                            
                        </li>
                        <li>
                            <b>Gradient Fill</b> - fill the selected cells with two colors which smoothly change from one to another.
                            <p><img alt="Gradient Fill" src="../images/cell_fill_gradient.png" /></p>
                            <ul>
                                <li><b>Angle</b> - manually specify an exact value in degrees that defines the gradient direction (colors change in a straight line at the specified angle).</li>
                                <li><b>Direction</b> - choose a predefined template from the menu. The following directions are available: top-left to bottom-right (<em>45&deg;</em>), top to bottom (<em>90&deg;</em>), top-right to bottom-left (<em>135&deg;</em>), right to left (<em>180&deg;</em>), bottom-right to top-left (<em>225&deg;</em>), bottom to top (<em>270&deg;</em>), bottom-left to top-right (<em>315&deg;</em>), left to right (<em>0&deg;</em>).</li>
                                <li><b>Gradient</b> - click on the left slider <div class = "icon icon-gradientslider"></div> under the gradient bar to activate the color box which corresponds to the first color. Click on the color box on the right to choose the first color in the palette. Drag the slider to set the gradient stop i.e. the point where one color changes into another. Use the right slider under the gradient bar to specify the second color and set the gradient stop.</li>
                            </ul>
                        </li>
                        <li>
                            <b>Pattern</b> - select this option to fill the selected cells with a two-colored design composed of regularly repeated elements.
                            <p><img alt="Pattern Fill" src="../images/cell_fill_pattern.png" /></p>
                            <ul>
                                <li><b>Pattern</b> - select one of the predefined designs from the menu.</li>
                                <li><b>Foreground color</b> - click this color box to change the color of the pattern elements.</li>
                                <li><b>Background color</b> - click this color box to change the color of the pattern background.</li>
                            </ul>
                        </li>
                        <li><b>No Fill</b> - select this option if you don't want to use any fill.</li>
                    </ul>
                </li>
            </ol>
                        
            <h3 id="cell_borders">Add cell borders</h3>
			<p>To add and format borders to a worksheet,</p>
			<ol>
				<li>select a cell, a range of cells with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination,
                <p class="note"><b>Note</b>: you can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
                </li>
				<li>click the <b>Borders</b> <div class = "icon icon-addborders"></div> icon situated at the <b>Home</b> tab of the top toolbar or click the <b>Cell settings</b> <div class = "icon icon-cellsettings_rightpanel"></div> icon at the right sidebar and use the <b>Borders Style</b> section,
                <p><img alt="Cell settings tab" src="../images/cellsettingstab.png" /></p>
                </li>
				<li>select the border style you wish to apply: 
                <ol>
                    <li>open the <b>Border Style</b> <div class = "icon icon-borderstyle"></div> submenu and select one of the available options, </li>
                    <li>open the <b>Border Color</b> <div class = "icon icon-bordercolor"></div> submenu or use the <b>Color</b> palette at the right sidebar and select the color you need from the palette,</li>
                    <li>select one of the available border templates: <b>Outside Borders</b> <div class = "icon icon-outsideborders"></div>, <b>All Borders</b> <div class = "icon icon-allborders"></div>, <b>Top Borders</b> <div class = "icon icon-topborders"></div>, <b>Bottom Borders</b> <div class = "icon icon-bottomborders"></div>, <b>Left Borders</b> <div class = "icon icon-leftborders"></div>, <b>Right Borders</b> <div class = "icon icon-rightborders"></div>, <b>No Borders</b> <div class = "icon icon-noborders"></div>, <b>Inside Borders</b> <div class = "icon icon-insideborders"></div>, <b>Inside Vertical Borders</b> <div class = "icon icon-insideverticalborders"></div>, <b>Inside Horizontal Borders</b> <div class = "icon icon-insidehorizontalborders"></div>, <b>Diagonal Up Border</b> <div class = "icon icon-diagonal_up_border"></div>, <b>Diagonal Down Border</b> <div class = "icon icon-diagonal_down_border"></div>.</li>
                </ol>
                </li>
			</ol>
		</div>
	</body>
</html>